wait to write MASS while MASS is changing
Short Description
Adaptive Server is attempting to write to a memory address space segment (MASS). A MASS is one or more contiguous pages Adaptive Server keeps in a data cache. However, in this event, the status of the MASS is “changing,” meaning another spid is updating the MASS. The spid initiating the write cannot write to the MASS until the MASS is no longer in use. A high value for WaitTime for event 30 may indicate that the data cache is too small, causing pages in the data cache to reach the wash area frequently, forcing the checkpoint process to perform more writes than necessary.
Search online
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.